package com.yz.group1.group_1.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yz.group1.group_1.entity.DoctorVisit; // 你的实体
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper          // 必须加
public interface DoctorVisitMapper extends BaseMapper<DoctorVisit> {
    @Select("SELECT * FROM visit_manage WHERE doctor_id=#{doctorId} AND visit_date=CURDATE() ORDER BY queue_no")
    List<DoctorVisit> todayQueue(Long doctorId);
}